<?php

class timer {  

    var $StartTime = 0;  

    var $StopTime = 0;  

    var $TimeSpent = 0;  

    function start(){  

        $this->StartTime = microtime();  

    }  

    function stop(){  

        $this->StopTime  = microtime();  

    }  


    function spent() {  

        if ($this->TimeSpent) {  

            return $this->TimeSpent;  

        } else {  

            $StartMicro = substr($this->StartTime,0,10);  

            $StartSecond = substr($this->StartTime,11,10);  

            $StopMicro  = substr($this->StopTime,0,10);  

            $StopSecond  = substr($this->StopTime,11,10);  

            $start = doubleval($StartMicro) + $StartSecond;  

            $stop  = doubleval($StopMicro) + $StopSecond;  

            $this->TimeSpent = $stop - $start;  

            return substr($this->TimeSpent,0,8);

        }  

    }  // end function spent();  

} //end class timer;  



$timer = new timer;
$timer->start();


//连接
$db = new PDO("mysql:host=localhost;dbname=ams", "root", "quanhz");

$sql = "SELECT * FROM ams_doubleclick_stat LIMIT 1000000";
$res = $db->query($sql);

/*
$res->setFetchMode(PDO::FETCH_ASSOC);
$rs = $res->fetchAll();
echo count($rs).'<hr>';
*/
$timer->stop();
file_put_contents('mysql.txt', $timer->spent()."\r\n", FILE_APPEND);
echo "time:".$timer->spent();
?>